${r'<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="'}${packageName}.mapper.${poName}${r'Mapper">'}

<!--模糊查询-->
${r'<select id="fuzzySearch" resultType="'}${packageName}.domain.${poName}${r'">'}
select
${allSqlColumn}
from ${tableName}
<where>
<#if columnBeanList?exists>
    <#list columnBeanList as model>
        ${r' <if test="'}${model.attrname}${r' != null ">'}
        or ${model.columnName} like ${r'#{'} ${model.attrname} ${r'}"%",
           </if>'}
    </#list>
</#if>
</where>
order by id desc
</select>
${r"</mapper> "}
